The SQLPrepare function registers a statement to be executed in SQL and executes it as a SQLExecute function.
void @SQLPrepare(int id, string query);
Parameters
int id :Access number connected by SQLConnect
string query : Query statement to run
Return Value
None
Example1
@SQLPrepare($AddrID, "DELETE from Table1 WHERE ID=1");
Description : Prepare
for the deletion of data from linked databases, Table1 tables, and ID number
fields.
Prepared SQL commands can be executed with SQLExecute functions.
Related Helps